package jdbc;

import java.sql.Connection;
import java.sql.SQLException;
import java.sql.Statement;

/*
执行UPDATE语句
 */
public class JDBCDemo3 {
    public static void main(String[] args) {

        try {
            Connection connection=DBUtil.getConnection();
            Statement statement=connection.createStatement();
            String sql="UPDATE userinfo " +
                    "SET password='123456' " +
                    "WHERE username='规则'";
            int num =statement.executeUpdate(sql);
            if(num>0){
                System.out.println("更新成功");
            }else {
                System.out.println("更新失败");
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}
